BEGIN TRANSACTION
ALTER TABLE dbo.Appconfig ADD
	ExporterParentAccount int NULL
GO
COMMIT

--------------------------


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_Bank]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_Bank]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_BankEForm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_BankEForm]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_BankItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_BankItem]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_BankPacking]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_BankPacking]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Invoice_BankRemit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Invoice_BankRemit]
GO

CREATE TABLE [dbo].[Invoice_Bank] (
	[Inv_BankID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[Inv_BankDate] [datetime] NOT NULL ,
	[Inv_BankVNo] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SessionID] [smallint] NOT NULL ,
	[Remarks] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ReadOnly] [bit] NOT NULL ,
	[LoginID] [int] NOT NULL ,
	[HostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EntryDateTime] [datetime] NULL ,
	[ModifyID] [int] NULL ,
	[ModifyHostName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[ModifyDateTime] [datetime] NOT NULL ,
	[BLDate] [datetime] NULL ,
	[ReturnDate] [datetime] NULL ,
	[BankDate] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ExporterID] [int] NULL ,
	[SupplierID] [int] NULL ,
	[ConsigneeID] [int] NULL ,
	[SubPartyID] [smallint] NULL ,
	[AgentID] [int] NULL ,
	[BankID] [int] NULL ,
	[TransporterID] [int] NULL ,
	[ShipID] [smallint] NULL ,
	[ShipLineID] [smallint] NULL ,
	[ContainerTypeID] [smallint] NULL ,
	[StatusID] [smallint] NULL ,
	[GD] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[BLNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[VoyNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Currency] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[BankRef] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EFormNo] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ContainerNo] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[NoOfContainers] [decimal](11, 2) NOT NULL ,
	[SumPkg] [numeric](15, 4) NOT NULL ,
	[SumNetWT] [decimal](15, 4) NOT NULL ,
	[SumGrossWT] [decimal](15, 4) NOT NULL ,
	[SumGWTotal] [decimal](15, 4) NOT NULL ,
	[SumQty] [numeric](15, 4) NOT NULL ,
	[Rate] [numeric](15, 4) NOT NULL ,
	[SumAmount] [numeric](15, 4) NOT NULL ,
	[NetInvoice] [decimal](15, 4) NOT NULL ,
	[SumRemit] [decimal](15, 4) NOT NULL ,
	[SumFBC] [decimal](15, 4) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Invoice_BankEForm] (
	[inv_BankEFormID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[inv_BankID] [bigint] NOT NULL ,
	[EFormID] [bigint] NULL ,
	[Type] [tinyint] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Invoice_BankItem] (
	[inv_BankItemID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[inv_BankID] [bigint] NOT NULL ,
	[StationID] [smallint] NULL ,
	[ItemID] [smallint] NULL ,
	[VarietyID] [smallint] NULL ,
	[LQTY] [numeric](15, 4) NOT NULL ,
	[Type] [tinyint] NOT NULL ,
	[ContainerNo] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Invoice_BankPacking] (
	[inv_BankPackID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[inv_BankID] [bigint] NOT NULL ,
	[ShipMarkID] [smallint] NULL ,
	[PackageID] [smallint] NULL ,
	[ItemID] [smallint] NULL ,
	[Pkg] [numeric](15, 4) NOT NULL ,
	[NetWT] [decimal](15, 4) NOT NULL ,
	[GrossWT] [decimal](15, 4) NOT NULL ,
	[GWTotal] [decimal](15, 4) NOT NULL ,
	[Qty] [numeric](15, 4) NOT NULL ,
	[Rate] [numeric](15, 4) NOT NULL ,
	[Amount] [numeric](15, 4) NOT NULL ,
	[Type] [tinyint] NOT NULL ,
	[ItemRemarks] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[RateRemarks] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Invoice_BankRemit] (
	[inv_BankRemitID] [bigint] IDENTITY (1, 1) NOT NULL ,
	[inv_BankID] [bigint] NOT NULL ,
	[BankID] [smallint] NULL ,
	[Remit] [numeric](15, 4) NOT NULL ,
	[FBC] [numeric](15, 4) NOT NULL ,
	[Type] [tinyint] NOT NULL ,
	[BankDate] [datetime] NOT NULL ,
	[EPRC] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Invoice_Bank] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_Bank] PRIMARY KEY  CLUSTERED 
	(
		[Inv_BankID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_BankEForm] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_BankEForm] PRIMARY KEY  CLUSTERED 
	(
		[inv_BankEFormID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_BankItem] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_BankItem] PRIMARY KEY  CLUSTERED 
	(
		[inv_BankItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_BankPacking] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_BankPacking] PRIMARY KEY  CLUSTERED 
	(
		[inv_BankPackID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Invoice_BankRemit] WITH NOCHECK ADD 
	CONSTRAINT [PK_Invoice_BankRemit] PRIMARY KEY  CLUSTERED 
	(
		[inv_BankRemitID]
	)  ON [PRIMARY] 
GO